0 (OBJECTIDIPARENTIDIOBJECTTYPEC OBJECTNAMECPROPERTYMCODEMRIINFOCUSERM Database Database  Database TransactionLog Database StoredProceduresSource b Database StoredProceduresObject  Database StoredProceduresDependencies Table Categories Table Customers Table Employees Table OrderDetails Table Orders Table Products Table Shippers ` Table Suppliers V Index customerid T  Index productid c  Index orderid ^  Index primarykey Z  Field orderid  Field productid  Field unitprice  Field quantity  Field discount :  Index categoryid  Index supplierid } Field customerid L Field companyname h Field contactname j Field contacttitle k Field address K Field city l Field region J Field postalcode m !Field country n "Field phone o #Field fax q $ Index postalcode U % Index customerid 9 & Index orderdate 8 ' Index shippeddat 6 ( Index employeeid . ) Index shipperid + *Index reportsto ) + Field shipperid , Field companyname , - Field phone . Index shipperid % /Field categoryid 0Field categoryname g 1Field description 2Field picture 3Index categorynm 4Index categoryid 5 Relation Relation 1 fRRI 6Index companynam ] 7Index city [ 8Index postalcode S 9Index region Q :Index lastname O ;Index postalcode = <View current_product_list ? =<Field productid ><Field productname - ?View alphabetical_list_of_products D @?Field productid K A?Field productname M B?Field supplierid O C?Field categoryid Q D?Field quantityperunit R E?Field unitprice T F?Field unitsinstock V G?Field unitsonorder X H?Field reorderlevel Z I?Field discontinued \ J?Field categoryname ^ KView product_sales_for_1997 ` LKField categoryname j MKField productname NKField productsales OView category_sales_for_1997 k POField categoryname QOField categorysales RView customer_and_suppliers_by_city SRField city TRField companyname URField contactname VRField relationship WView order_details_extended XWField orderid YWField productid ZWField productname [WField unitprice \WField quantity ]WField discount ^WField extendedprice _View order_subtotals `_Field orderid a_Field subtotal bView orders_qry 5 cbField orderid 4 dbField customerid 3 ebField employeeid 2 fbField orderdate 1 gbField requireddate 0 hbField shippeddate / ibField shipvia . jbField freight - kbField shipname , lbField shipaddress + mbField shipcity * nbField shipregion ) obField shippostalcode ' pbField shipcountry & qbField companyname $ rbField address # sbField city " tbField region ! ubField postalcode  vbField country  wView products_above_average_price  xwField productname  ywField unitprice  zView products_by_category  {zField categoryname  |zField productname  }zField quantityperunit  ~zField unitsinstock  zField discontinued  View quarterly_orders Field customerid Field companyname Field city Field country View sales_totals_by_amount Field saleamount Field orderid Field companyname Field shippeddate View sales_by_category Field categoryid Field categoryname Field productname Field productsales View ten_most_expensive_products Field tenmostexpensiveproducts Field unitprice Relation Relation 1 iCRI Relation Relation 2 $RRI Index companynam e Field productid Field productname t Field supplierid @ Field categoryid ? Field quantityperunit Field unitprice Field unitsinstock Field unitsonorder Field reorderlevel Field discontinued Index productnam _ Index productid  Relation Relation 1 RRI Field employeeid E Field lastname < Field firstname * Field title " Field titleofcourtesy C Field birthdate Field hiredate  Field address  Field city  Field region  Field postalcode  Field country  Field homephone  Field extension  Field photo  Field notes  Field reportsto  Index employeeid G Relation Relation 1 RRI Relation Relation 3 RRI View invoices  Field shipname  Field shipaddress  Field shipcity  Field shipregion  Field shippostalcode  Field shipcountry  Field customerid  Field customername  Field address  Field city  Field region  Field postalcode  Field country  Field salesperson  Field orderid  Field orderdate  Field requireddate  Field shippeddate  Field shippername  Field productid  Field productname  Field unitprice  Field quantity  Field discount  Field extendedprice  Field freight  Field orderid 7 Field customerid u Field employeeid 5 Field orderdate w Field requireddate x Field shippeddate y Field shipvia 4 Field freight s Field shipname 2 Field shipaddress 0 Field shipcity z Field shipregion / Field shippostalcode { Field shipcountry | Index orderid & Relation Relation 2 #RCI Field supplierid ~ Field companyname \ Field contactname R Field contacttitle Field address ( Field city P Field region ' Field postalcode N Field country > Field phone X Field fax H Field homepage A Index supplierid d Relation Relation 2 bRRI Table Territories y Field territoryid  Field territorydescription  Field regionid  Index territoryi  Index regionid  Table EmployeeTerritories  Field employeeid  Field territoryid  Index employeeid  Index territoryi  Relation Relation 1 RRI Relation Relation 2 ~RCI Table CustomerDemographics { Field customertypeid  Field customerdesc  Index custtypeid  Table CustomerCustomerDemo  Field customerid  Field customertypeid  Index customerid  Index custtypeid  Relation Relation 1 RRI Relation Relation 2 RRI View summary_of_sales_by_year  Field year w Field total x View summary_of_sales_by_quarter   Field year   Field quarter   Field total  Table Region u Field regionid q Field regiondescription r Index regionid s Relation Relation 1 tRRI